Film_Locations_in_San_Francisco

5 rows where Actor 1 = 252

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
56	56	American Graffiti 18	1973 16	Mel's Drive-In (Corner of Van Ness & Mission Street, Mission District)	This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd.	Universal Pictures 15	Universal Pictures' 14	George Lucas 17	George Lucas 16	Richard Dreyfuss 252	Ron Howard 16	Paul Le Mat 445
57	57	American Graffiti 18	1973 16	3355 Geary Blvd.		Universal Pictures 15	Universal Pictures' 14	George Lucas 17	George Lucas 16	Richard Dreyfuss 252	Ron Howard 16	Paul Le Mat 445
715	715	James and the Giant Peach 139	1996 43			Skellington Productions 94	Walt Disney Studios Home Entertainment 62	Henry Selick 129	Karey Kirkpatrick 128	Richard Dreyfuss 252	Jane Leeves 114
1332	1332	The Competition 248	1980 34	Pier 39		Columbia Pictures Corporation 5	American Broadcasting Company (ABC) 51	Joel Oliansky 204	Joel Oliansky 215	Richard Dreyfuss 252	Amy Irving 190	Lee Remick 57
1333	1333	The Competition 248	1980 34	California Academy of Sciences (Golden Gate Park)	Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States.	Columbia Pictures Corporation 5	American Broadcasting Company (ABC) 51	Joel Oliansky 204	Joel Oliansky 215	Richard Dreyfuss 252	Amy Irving 190	Lee Remick 57

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");